﻿CREATE TABLE [dbo].[Committees] (
    [Id]                                        NVARCHAR (100) NOT NULL,
    [Title]                                     NVARCHAR (MAX) NOT NULL,
    [DateAppointed]                             DATETIME       NOT NULL,
    [DateCompleted]                             DATETIME       NULL,
    [Status]                                    NVARCHAR (MAX) NOT NULL,
    [Type]                                      NVARCHAR (MAX) NOT NULL,
    [Summary]                                   NVARCHAR (MAX) NOT NULL,
    [IndexedContent]                            NVARCHAR (MAX) NOT NULL,
    [Link]                                      NVARCHAR (MAX) NOT NULL,
    [ParliamentNumber]                          INT            NOT NULL,
    [Chamber]                                   NVARCHAR (MAX) NOT NULL,
    [Joint]                                     BIT            NOT NULL,
    [LastModified]                              DATETIME       NOT NULL,
    [CommitteeGenericSearchResult_Committee_Id] NVARCHAR (100) NOT NULL
);



